<?xml version="1.0"?>
<CsvDataLoaderParams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TableMetadataEntity>
    <Name>Public Space Permits</Name>
    <Category>Economic Development</Category>
    <Description>Provides current public space permits granted by the Department of Transportation (DDOT)</Description>
    <Source>DDOT Public Space Permitting</Source>
    <LastUpdateDate>2009-03-26T00:00:00</LastUpdateDate>
    <MetadataUrl>http://data.octo.dc.gov/Metadata.aspx?id=6</MetadataUrl>
    <EntitySet>PublicSpacePermits</EntitySet>
    <EntityKind>PublicSpacePermit</EntityKind>
	<IsEmpty>true</IsEmpty>
  </TableMetadataEntity>
  <ProducerParams>
    <PlacemarkParams>
      <LatitudeProperty>LATITUDE</LatitudeProperty>
      <LongitudeProperty>LONGITUDE</LongitudeProperty>
      <NamePropertyFormatString>Site Address:{0} Owner: {1} Application Date: {2} Expiration Date: {3}</NamePropertyFormatString>
      <NameProperties>
        <string>SITEADDRESS</string>
        <string>OWNEROFPREMISE</string>
        <string>APPLICATIONDATETIME</string>
        <string>EXPIRATIONDATETIME</string>
      </NameProperties>
    </PlacemarkParams>
    <PropertyToTypeMap>
      <TRACKING_NO>string</TRACKING_NO>
      <PERMITNO>string</PERMITNO>
      <PERMITTEE>string</PERMITTEE>
      <PERMITDESCRIPTION>string</PERMITDESCRIPTION>
      <OWNEROFPREMISE>string</OWNEROFPREMISE>
      <OWNERADDRESS>string</OWNERADDRESS>
      <AGENTNAME>string</AGENTNAME>
      <AGENTADDRESS>string</AGENTADDRESS>
      <APPLICATIONDATETIME>DateTime</APPLICATIONDATETIME>
      <ISSUEDDATETIME>DateTime</ISSUEDDATETIME>
      <EFFECTIVEDATETIME>DateTime</EFFECTIVEDATETIME>
      <EXPIRATIONDATETIME>DateTime</EXPIRATIONDATETIME>
      <STATUS>string</STATUS>
      <LASTMODIFIEDDATE>DateTime</LASTMODIFIEDDATE>
      <PAVINGPERMITTYPE>bool-0or1</PAVINGPERMITTYPE>
      <PUBLICSPACEOCCUPANCYPERMIT>bool-0or1</PUBLICSPACEOCCUPANCYPERMIT>
      <STREETFIXTUREPERMIT>bool-0or1</STREETFIXTUREPERMIT>
      <LANDSCAPINGPERMIT>bool-0or1</LANDSCAPINGPERMIT>
      <EXCAVATIONPERMIT>bool-0or1</EXCAVATIONPERMIT>
      <PROJECTIONSPERMIT>bool-0or1</PROJECTIONSPERMIT>
      <PSRRENTALPERMIT>bool-0or1</PSRRENTALPERMIT>
      <CITY>string</CITY>
      <STATE>string</STATE>
      <SITEADDRESS>string</SITEADDRESS>
      <LATITUDE>double</LATITUDE>
      <LONGITUDE>double</LONGITUDE>
      <ZIPCODE>string</ZIPCODE>
      <MARADDRESSREPOSITORYID>string</MARADDRESSREPOSITORYID>
      <DCSTATADDRESSKEY>string</DCSTATADDRESSKEY>
      <DCSTATLOCATIONKEY>string</DCSTATLOCATIONKEY>
      <WARD>string</WARD>
      <ANC>string</ANC>
      <SMD>string</SMD>
      <DISTRICT>string</DISTRICT>
      <PSA>string</PSA>
      <NEIGHBORHOODCLUSTER>string</NEIGHBORHOODCLUSTER>
      <BUSINESSIMPROVEMENTDISTRICT>string</BUSINESSIMPROVEMENTDISTRICT>
    </PropertyToTypeMap>
  </ProducerParams>
  <ProcessorParams>
    <PartitionKeyPropertyName>PERMITTEE</PartitionKeyPropertyName>
    <RowKeyPropertyName>TRACKING_NO</RowKeyPropertyName>
    <TableMetadataPartitionKeyPropertyName>Name</TableMetadataPartitionKeyPropertyName>
    <TableMetadataRowKeyPropertyName>New.Guid</TableMetadataRowKeyPropertyName>
    <EntityMetadataPartitionKeyPropertyName>EntitySet</EntityMetadataPartitionKeyPropertyName>
    <EntityMetadataRowKeyPropertyName>EntityKind</EntityMetadataRowKeyPropertyName>
  </ProcessorParams>
</CsvDataLoaderParams>